{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RE 75-2","Instructions","Guidance&Regulations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RE 75-2","index":0,"n_rows":181,"n_cols":20,"rows_kept":181,"cut":false,"hidden":false,"merged":[[166,4,166,6],[179,4,179,6],[14,6,14,12],[15,6,15,8],[16,6,16,8],[111,8,111,10],[163,4,163,6],[164,4,164,6],[135,4,135,16],[177,4,177,6],[131,0,131,12],[133,0,133,12],[127,8,127,10],[147,8,147,12],[143,8,143,12],[165,4,165,6],[1,19,1,24],[155,5,155,12],[157,5,157,12],[141,8,141,12],[145,8,145,12],[137,0,137,12],[13,19,13,24],[3,6,3,8],[4,6,4,8],[5,6,5,8],[7,6,7,8],[8,0,8,2],[9,6,9,8],[6,6,6,12],[12,0,12,12],[4,10,4,12],[5,10,5,12],[7,10,7,12],[8,6,8,8],[139,8,139,12],[161,4,161,10],[172,4,172,6],[178,4,178,6],[169,4,169,6],[170,4,170,6],[167,4,167,6],[171,4,171,6],[168,4,168,6],[173,4,173,6]]}
["RE 75-2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","Adams (District 9)","1 & Partial","ADA",9]
["Revised 10/15/18",null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Allen (District 1)","2 & Partial","ALL",1,"Click Here for Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ashland (District 3)","3 & Partial","ASD",3]
["Utility",null,null,null,null,null,"County (Counties)",null,null,null,null,null,null,null,null,"Ashtabula (District 4)","4 & Partial","ATB",4]
["Street Address",null,null,null,null,null,"Route No.",null,null,null,null,null,null,null,null,"Athens (District 10)","5 & Partial","ATH",10]
["City, State, Zip",null,null,null,null,null,"Section",null,null,null,null,null,null,null,null,"Auglaize (District 7)","6 & Partial","AUG",7]
["Tax ID No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belmont (District 11)","7 & Partial","BEL",11]
["Work Order No.",null,null,null,null,null,"PID #",null,null,null,null,null,null,null,null,"Brown (District 9)","8 & Partial","BRO",9]
["Invoice/Bill No.",null,null,null,null,null,"ODOT District",null,null,null,{"$f":"IF(ISBLANK(K4),\"\",VLOOKUP(K4,R:S,2,FALSE))","v":""},null,{"$f":"IF(ISBLANK(M4),\"\",VLOOKUP(M4,R:S,2,FALSE))","v":""},null,null,"Butler (District 8)","9 & Partial","BUT",8]
["Final/Partial Bill",null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,"Carroll (District 11)","10 & Partial","CAR",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Champaign (District 7)","11 & Partial","CHP",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clark (District 7)","12 & Partial","CLA",7]
["SUMMARY OF BILLING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clermont (District 8)","13 & Partial","CLE",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinton (District 8)","14 & Partial","CLI",8,"Click Here for Guidance"]
[null,null,null,null,"Invoice May be Audited At:",null,null,null,null,null,null,null,null,null,null,"Columbiana (District 11)","15 & Partial","COL",11]
[null,null,null,null,"Date Construction Work Started:",null,null,null,null,null,null,null,null,null,null,"Coshocton (District 5)","16 & Partial","COS",5]
[null,null,null,null,"Date Construction Work Completed:",null,null,null,null,null,{"$f":"IF(ISBLANK(G16),\"<--Enter Dates\",CONCATENATE(G17-G16+1,\" days\"))","v":"<--Enter Dates"},null,null,null,null,"Crawford (District 3)","17 & Partial","CRA",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuyahoga (District 12)","18 & Partial","CUY",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Darke (District 7)","19 & Partial","DAR",7]
["A. Preliminary Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defiance (District 1)","20 & Partial","DEF",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delaware (District 6)","1 & Final","DEL",6]
[null,"1. Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Erie (District 3)","2 & Final","ERI",3]
[null,null,"a. Salaries and Wages",null,null,null,null,null,null,null,null,null," ",null,null,"Fairfield (District 5)","3 & Final","FAI",5]
[null,null,"b. Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Fayette (District 6)","4 & Final","FAY",6]
[null,null,"c. Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Franklin (District 6)","5 & Final","FRA",6]
[null,null,"d. Subconsultant Engineering",null,null,null,null,null,null,null,{"$f":"SUM(I23:I26)","v":0},null,null,null,null,"Fulton (District 2)","6 & Final","FUL",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallia (District 10)","7 & Final","GAL",10]
[null,"2. Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,"Geauga (District 12)","8 & Final","GEA",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greene (District 8)","9 & Final","GRE",8]
[null,"3. Transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Guernsey (District 5)","10 & Final","GUE",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hamilton (District 8)","11 & Final","HAM",8]
[null,"4.  Total Preliminary Engineering",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K30,K28,K26)","v":0},null,null,"Hancock (District 1)","12 & Final","HAN",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardin (District 1)","13 & Final","HAR",1]
["B.  Right of Way Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrison (District 11)","14 & Final","HAS",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Henry (District 2)","15 & Final","HEN",2]
[null,"1. Property Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Highland  (District 9)","16 & Final","HIG",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hocking (District 10)","17 & Final","HOC",10]
[null,"2.  Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Holmes (District 11)","18 & Final","HOL",11]
[null,null,"a.  Salaries and Wages",null,null,null,null,null,null,null,null,null,null,null,null,"Huron (District 3)","19 & Final","HUR",3]
[null,null,"b. Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Jackson (District 9)","20 & Final","JAC",9]
[null,null,"c.  Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Jefferson (District 11)",null,"JEF",11]
[null,null,"d.  Subcontracted Right of Way Acquisition",null,null,null,null,null,null,null,{"$f":"SUM(I39:I42)","v":0},null,null,null,null,"Knox (District 5)",null,"KNO",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lake (District 12)",null,"LAK",12]
[null,"3.  Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lawrence (District 9)",null,"LAW",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Licking (District 5)",null,"LIC",5]
[null,"4.  Transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Logan (District 7)",null,"LOG",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lorain (District 3)",null,"LOR",3]
[null,"5.  Total Property Costs",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K36,K42,K44,K46)","v":0},null,null,"Lucas (District 2)",null,"LUC",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Madison (District 6)",null,"MAD",6]
["C.  Temporary Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mahoning (District 4)",null,"MAH",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marion (District 6)",null,"MAR",6]
[null,"1.  Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Medina (District 3)",null,"MED",3]
[null,null,"a. Salaries and Wages",null,null,null,null,null,null,null,null,null,null,null,null,"Meigs (District 10)",null,"MEG",10]
[null,null,"b. Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Mercer (District 7)",null,"MER",7]
[null,null,"c. Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Miami (District 7)",null,"MIA",7]
[null,null,"d. Subcontracted Construction",null,null,null,null,null,null,null,{"$f":"SUM(I53:I56)","v":0},null,null,null,null,"Monroe (District 10)",null,"MOE",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montgomery (District 7)",null,"MOT",7]
[null,"2.  Material (Itemized)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Morgan (District 10)",null,"MRG",10]
[null,null,"a.  New Stock Materials",null,null,null,null,null,null,null,null,null,null,null,null,"Morrow (District 6)",null,"MOR",6]
[null,null,"b.  Purchased Materials",null,null,null,null,null,null,null,null,null,null,null,null,"Muskingum (District 5)",null,"MUS",5]
[null,null,"c.  Salvage",null,null,null,null,null,null,null,null,null,null,null,null,"Noble (District 10)",null,"NOB",10]
[null,null,"d.  Material Handling/Stores (Stock Materials Only)",null,null,null,null,null,null,null,{"$f":"SUM(I59:I62)","v":0},null,null,null,null,"Ottawa (District 2)",null,"OTT",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paulding (District 1)",null,"PAU",1]
[null,"3.  Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,"Perry (District 5)",null,"PER",5]
[null,null,"a.  Utility Owned",null,null,null,null,null,null,null,null,null,null,null,null,"Pickaway (District 6)",null,"PIC",6]
[null,null,"b.  Rented",null,null,null,null,null,null,null,{"$f":"SUM(I65:I66)","v":0},null,null,null,null,"Pike (District 9)",null,"PIK",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portage (District 4)",null,"POR",4]
[null,"4.  Total Temporary Construction",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K66,K62,K56)","v":0},null,null,"Preble (District 8)",null,"PRE",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Putnam (District 1)",null,"PUT",1]
["D.  Permanent Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Richland (District 3)",null,"RIC",3]
[null,"1.  Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ross (District 9)",null,"ROS",9]
[null,null,"a. Salaries and Wages",null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky (District 2)",null,"SAN",2]
[null,null,"b. Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Scioto (District 9)",null,"SCI",9]
[null,null,"c. Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Seneca (District 2)",null,"SEN",2]
[null,null,"d. Subcontracted Construction",null,null,null,null,null,null,null,{"$f":"SUM(I72:I75)","v":0},null,null,null,null,"Shelby (District 7)",null,"SHE",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stark (District 4)",null,"STA",4]
[null,"2.  Material (Itemized)",null,null,null,null,null,null,null,null,null,null,null,null,null,"State Wide (District Multiple)",null,"STW","Multiple"]
[null,null,"a.  New Stock Materials",null,null,null,null,null,null,null,null,null,null,null,null,"Summit (District 4)",null,"SUM",4]
[null,null,"b.  Purchased Materials",null,null,null,null,null,null,null,null,null,null,null,null,"Trumbull (District 4)",null,"TRU",4]
[null,null,"c.  Salvage",null,null,null,null,null,null,null,null,null,null,null,null,"Tuscarawas (District 11)",null,"TUS",11]
[null,null,"d.  Material Handling/Stores (Stock Materials Only)",null,null,null,null,null,null,null,{"$f":"SUM(I78:I81)","v":0},null,null,null,null,"Union (District 6)",null,"UNI",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Van Wert (District 1)",null,"VAN",1]
[null,"3.  Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vinton (District 10)",null,"VIN",10]
[null,null,"a.  Utility Owned",null,null,null,null,null,null,null,null,null,null,null,null,"Warren (District 8)",null,"WAR",8]
[null,null,"b.  Rented",null,null,null,null,null,null,null,{"$f":"SUM(I84:I85)","v":0},null,null,null,null,"Washington (District 10)",null,"WAS",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wayne (District 3)",null,"WAY",3]
[null,"4.  Total Permanent Construction",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K75,K81,K85)","v":0},null,null,"Williams (District 2)",null,"WIL",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood (District 2)",null,"WOO",2]
["E.  Construction Engineering and Inspection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wyandot (District 1)",null,"WYA",1]
[]
[null,"1. Labor"]
[null,null,"a. Salaries and Wages"]
[null,null,"b. Fringe Benefits to Labor"]
[null,null,"c. Meals, Lodging and Travel"]
[null,null,"d. Subconsultant Engineering",null,null,null,null,null,null,null,{"$f":"SUM(I92:I95)","v":0}]
[]
[null,"2. Supplies"]
[]
[null,"3. Transportation"]
[]
[null,"4.  Total Construction Engineering",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K95,K97,K99)","v":0}]
[]
["F.  Accounting/Billing"]
[]
[null,"1.  Labor"]
[null,null,"a. Salaries and Wages"]
[null,null,"b. Fringe Benefits to Labor"]
[]
[null,"4.  Total Accounting/Billing",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I106:I107)","v":0}]
[]
["G.  General and Administrative Overhead"]
[]
[]
[]
["Allowable G&A overhead in accordance with 23 CFR 645.117(d) and 48 CFR 31."]
[]
["H.  Total Costs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M32,M48,M68,M87,M101,M109,M115)","v":0}]
[]
["I.  Less Betterment (Must be a credit balance)"]
[]
["J.  Less Accrued Depreciation (Must be a credit balance)"]
[]
["K.  Total Allowable Actual Cost per 23 CFR 645.117",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M117,M119,M121)","v":0}]
[]
[null,null,null,null,"Total Units Relocated"]
[null,null,null,null,"Total Units Reimbursable to Utility"]
[null,null,null,null,"Percentage Utility Participation",null,{"$f":"ROUND(IF(ISBLANK(G125),1,1-G126/G125),4)","v":1},null,null,null,"Utility Partcicpation",null,{"$f":"IF(ISERROR(G128),\"\",IF(G126>G125,\"error in cell G126\",(M123*G127)))","v":0}]
[null,null,null,null,"Percentage ODOT Participation",null,{"$f":"1-G127","v":0},null,"ODOT Participation (Amount Due Utility)",null,null,null,{"$f":"IF(ISERROR(G128),\"\",IF(G126>G125,\"error in cell G126\",(M123*G128)))","v":0}]
[]
[]
[]
["I hereby certify that to the best of my knowledge and belief this bill is true and correct and that all costs included herein are properly chargeable to the Project as a result of rearranging our facilities to conform to the above named highway project as shown by this Utility's plan and estimate on file with the Ohio Department of Transportation.  In addition, all costs claimed and billed are in accordance with the executed Master Utility Reimbursement Agreement between ODOT and the Utility, all applicable laws, regulations and policies, including but not limited to 23 CFR 645, 48 CFR 31, the \"Buy America\" requirements contained in 23 USC 313 and 23 CFR 635.410, the ODOT Office of Real Estate Utilities Manual, and other Federal, State and ODOT regulations or polices."]
[]
["I further certify that all contractual work billed hereon has been completed and payment made in accordance with the contract; that the cost of property billed here is for property acquired and paid for in connection with this project; and that no collusion exists or has existed between members or employees of this firm and other persons, firms or corporations in order to establish an unjust basis for any part of the costs covered by the invoice."]
[]
[null,null,null,null,"By checking box, utility agrees to conform to the \"Buy America\" policy.  If box is unchecked, ODOT cannot process utility billing for final payment. "]
[]
["\"Buy America\" requires: \"STEEL AND IRON PRODUCTS MADE IN THE UNITED STATES\".  Furnish steel and iron products that are made in the United States according to the applicable provisions of Federal regulations stated in CFR 635.410.  \"United States\" means the United States of America and includes all territory, continental or insular, subject to jurisdiction of the United States.\n     Federal Requirements:  All steel or iron products incorporated permanently into the utility relocation work must be made of steel or iron produced in the United States and all subsequence manufacturing must be performed in the United States.  Manufacturing is any process that modifies the chemical content; physical shape or size; or final finish of a product.  Manufacturing begins with the initial melting and mixing, and continues through the bending and coating stages.  If a domestic product is taken out of the United States for any process, it becomes a foreign source material and is not acceptable.\n     Proof of Domestic Origin:  Furnish documentation to the ODOT District Utility Coordinator showing the domestic origin of all steel and iron products covered by this section before they are incorporated into the utility relocation work. If \"Buy America\" regulations are not adhered to, then any relocation work will not be reimbursed."]
[]
[null,null,null,null,null,null,null,null,"(Utility Name - Print or Type)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E4),\"\",E4)","v":""}]
[]
[null,null,null,null,null,null,null,null,"(Print or Type)"]
[]
[null,null,null,null,null,null,"Name"]
[]
[null,null,null,null,null,null,"Title"]
[]
[null,null,null,null,null,null,"Phone #"]
[]
[null,null,null,null,null,null,"Email"]
[]
[]
[]
[null,null,null,null,null,"Authorizing Signature"]
[]
[null,null,null,null,null,"(Please print and submit with other requested documentation)"]
[]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"COST SUMMARY - \",\"PID \",K8,\" - \",E4)","v":"COST SUMMARY - PID  - "}]
[null,null,null,null,null,null,null,null,"$$$",null,"% of Total Cost"]
[null,null,null,null,"Salaries and Wages",null,null,null,{"$f":"SUM(I23,I39,I53,I72,I92,I106)","v":0},null,{"$f":"IF(ISERROR(I164/$I$175),\"\",I164/$I$175)","v":""}]
[null,null,null,null,"Fringe Benefits",null,null,null,{"$f":"SUM(I24,I40,I54,I73,I93,I107)","v":0},null,{"$f":"IF(ISERROR(I165/$I$175),\"\",I165/$I$175)","v":""}]
[null,null,null,null,"Engineering Subconsultants",null,null,null,{"$f":"SUM(I26,I95,I42)","v":0},null,""]
[null,null,null,null,"Construction Subcontractors",null,null,null,{"$f":"SUM(I56,I75)","v":0},null,""]
[null,null,null,null,"General and Administrative Overhead",null,null,null,{"$f":"M115","v":0},null,""]
[null,null,null,null,"Meals, Lodging and Travel",null,null,null,{"$f":"SUM(I25,I41,I55,I74,I94)","v":0},null,""]
[null,null,null,null,"Materials and Handling",null,null,null,{"$f":"SUM(I59:I60,I78:I79,I62,I81)","v":0},null,""]
[null,null,null,null,"Equipment",null,null,null,{"$f":"SUM(I84:I85,I65:I66)","v":0},null,""]
[null,null,null,null,"Salvage, Betterments and Depreciation",null,null,null,{"$f":"SUM(I61,I80,M119,M121)","v":0},null,""]
[null,null,null,null,"Property Costs",null,null,null,{"$f":"SUM(K36)","v":0},null,""]
[null,null,null,null,"Supplies and Transportation",null,null,null,{"$f":"SUM(K28,K30,K44,K46,K97,K99)","v":0},null,""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I164:I174)","v":0},null,{"$f":"SUM(K164:K174)","v":0}]
[]
[]
[null,null,null,null,"Labor, Including Fringe Benefits",null,null,null,{"$f":"SUM(I164:I165)","v":0},null,{"$f":"IF(ISERROR(I178/$I$181),\"\",I178/$I$181)","v":""}]
[null,null,null,null,"Non-Salary Direct Costs",null,null,null,{"$f":"SUM(I166:I167,I169:I174)","v":0},null,{"$f":"IF(ISERROR(I179/$I$181),\"\",I179/$I$181)","v":""}]
[null,null,null,null,"General and Administrative Overhead",null,null,null,{"$f":"I168","v":0},null,{"$f":"IF(ISERROR(I180/$I$181),\"\",I180/$I$181)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I178:I180)","v":0},null,{"$f":"SUM(K178:K180)","v":0}]

{"sheet":"Instructions","index":1,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Prepared by the ODOT Office of Audits - Last updated on 8/19/09."]
[]
["The following provides guidance on the proper completion of ODOT Utilities form RE 75-2."]
[]
["All cells in gray may be edited by the user.  All other cells contain formulas that cannot be edited.  Do not alter any formulas contained in this spreadsheet."]
["Parts of this spreadsheet contain \"cell validation,\" which prevents the user from entering invalid data.  For example, salvage credits will only accept negative values."]
[]
["The following provides explanations as to the proper entry of data and some of the validations that exist to prevent the improper entry of data:"]
[]
["Field","Comment(s)"]
["Tax ID No.","Enter the Tax ID Number of the Utility.  Tax ID Numbers contain nine (9) digits.  You may include or exclude the dash after the second digit."]
["Work Order No.","This is the the project identification number assigned by the Utility for this project."]
["Invoice/Bill No.","This is the invoice number generated by the Utility's accounting system."]
["Final/Partial Bill","This cell signifies the invoice number to ODOT, starting with #1 being the initial invoice.  For example, if this is the second invoice, and it is the final invoice, it would be \"2 & Final.\"  If this is the first invoice and it is not the final invoice, it would be \"1 & partial.\"  Select the appropriate choice from the drop-down menu."]
["County","This is the 3-letter ODOT abbreviation for the County in which the project took place.  Select from the drop-down menu.  Cell K-8 will \"auto populate\" the appropriate district based upon the County chosen."]
["County (2)","If the project took place in two counties, this cell is available if necessary."]
["PID","Enter the four or five-digit ODOT PID (Project Identification Number)."]
["Salaries and Wages","Enter the amount of wages paid to employees of the Utility for this cost category."]
["Fringe Benefits","Enter the Fringe Benefit costs paid to or on behalf of the associated labor.  If it is the policy of the utility to apply \"loaded\" wage rates, in that fringe benefits and/or other indirect costs are include in the rates claimed on the relocation, it is permissible to include all of these costs under \"salaries and wages.\"  If the firm claims actual pay rates, fringes must be included here."]
["Meals, Lodging and Travel","Enter the meal, lodging and travel costs (vehicle mileage/airfare) associated with employees working in the cost category.  There should be no costs for subconsultants here."]
["Subconsultant Engineering","Enter the total cost of all subconsultants used in this cost category, including direct labor, overhead, non-salary direct costs, and any other costs incurred by the subconsultant.  No costs of the Utility should be shown here."]
["Supplies","Enter any supply costs incurred by the Utility used in this cost category."]
["Transportation","Enter any transportation costs incurred by the Utility used in this cost category that have not already been claimed under Meals, Lodging, and Travel.  Per Federal regulations, mileage reimbursement cannot exceed limits provided in the Federal Travel Regulation."]
["Property Costs","Include all property purchase Right-of-Way costs not included in other Right-of-Way cost categories."]
["Subcontracted Engineering","Enter the total cost of all subcontractors used in this cost category, including direct labor, overhead, non-salary direct costs, and any other costs incurred by the subconsultant.  No costs of the Utility should be shown here."]
["New Stock Materials","Enter the total stock value of all materials used on the project from the stock of the Utility."]
["Purchased Materials","Enter the total value of all materials purchased and shipped to the project site, including shipping costs.  Amounts estimated for gas loss (if applicable) may be included here."]
["Salvage","Enter the total amount credited to the project for material salvaged in this cost category.  The spreadsheet will only accept negative amounts.  You may leave the cell blank if no salvage is attributable to the project."]
["Material Handling","The Utility has the option to charge its \"stores\" rate for stock materials or 5%, per Federal guidelines.  Stores may not be applied to materials purchased and shipped to the job site."]
["Owned Equipment","Enter the actual cost of equipment used on the project that is owned by the Utility."]
["Rented Equipment","Enter the actual cost of equipment used on the project that rented by the Utility."]
["G&A Overhead Rate","Enter the General and Administrative Overhead costs allocable to the project.  Each utility has its own title for these costs (e.g. A&G, SG&A, overhead, etc.).  The general premise is that G&A allows the utility to recover indirect costs incurred by the utility in the overall management of the business segment."]
["Total Costs","This cell auto-calculates the total of all costs represented on the spreadsheet."]
["Betterments","Enter any betterments to the facility that are creditable to the project.  This cell only accepts credits."]
["Accrued Depreciation","Enter any accrued depreciation creditable to the project.  This cell only accepts credits."]
["Total Units Relocated","Enter the total number of units relocated on the project.  This may be represented in any units agreed to between ODOT and the Utility, such as poles, linear feet, etc."]
["Total Units Reimbursable","Enter the total number of existing units relocated that are reimbursable to the Utility, as agreed to between ODOT and the Utility.  The number of reimbursable units cannot exceed the total number of units relocated."]
["Amount Due Utility","This cell auto-calculates the total amount reimbursable to the Utility, as represented on the spreadsheet."]
["Summary","Please enter the name and title of the individual approving the submission of this form.  Print the form, sign it, and submit with any documentation required by the ODOT Office of Utilities."]

{"sheet":"Guidance&Regulations","index":2,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["The following regulations are required on utility relocation projects.  You may click on the text to link to the appropriate website."]
[]
["23 CFR 645: Utilities - Specifically, 645.117 addresses reimbursement of claimed relocation costs."]
[]
["48 CFR 31 (FAR Part 31): Contract Cost Principles - Addresses the allowability of costs included in overhead (indirect costs).  Note:  Certain costs cannot be claimed on Federal-Aid contracts and must be excluded from overhead."]
[]
["ODOT Office of Utilities Real Estate Manual - Addresses programmatic as well as billing issues."]
[]
["ODOT Utility Audit Policies and Guidance."]
[]
["Other Helpful Guidance / Websites"]
[]
["48 CFR 22.103: Labor Policies (Overtime)"]
[]
["DCAAP 7641.90: Information for Contractors"]
[]
["PUCO"]
[]
["Federal Energy Regulatory Commission"]
[]
["Federal-Aid Policy Guide 645: Utilities"]